package com.five.dao.impl.reception;

import com.five.dao.reception.ShowFacilityDao;
import com.five.util.DBUtil;

import java.util.List;
import java.util.Map;

/**
 * @Author: 王登峰
 * @Description:
 * @Date: 2020/11/18 18:36
 */
public class ShowFacilityDaoImpl implements ShowFacilityDao {
    @Override
    public List<Map> select(String name) {
        String sql = "select c.id,c.name Rtype,b.name Fname,b.inco from t_showfac_troom a\n" +
                "join t_showfac b on a.showfcid = b.id\n" +
                "join t_type c on a.troomid = c.id where c.name =?";
        return   DBUtil.queryMap(sql,name);
    }
}
